inherited frmPosScoreBackBill: TfrmPosScoreBackBill
  Caption = #31215#20998#36820#29616
  PixelsPerInch = 96
  TextHeight = 12
  inherited pnlDBCtrl: TPanel
    inherited pnlThirdtrade: TPanel
      inherited edtTTtraderid: TcxDBLookupComboBox
        ExplicitHeight = 21
      end
      inherited lblTTtraderid: TcxLabel
        AnchorX = 78
      end
      inherited cxLabel1: TcxLabel
        AnchorX = 262
      end
      inherited edtTTamount: TcxDBCalcEdit
        ExplicitHeight = 21
      end
      inherited edtTTremark: TcxDBTextEdit
        ExplicitHeight = 21
      end
      inherited edtTTBalanceid: TcxDBLookupComboBox
        ExplicitHeight = 21
      end
      inherited edtTTAccountid: TcxDBLookupComboBox
        ExplicitHeight = 21
      end
      inherited lblTTBalanceid: TcxLabel
        AnchorX = 469
      end
      inherited edtTTBalanceamt: TcxDBCalcEdit
        ExplicitHeight = 21
      end
    end
    inherited lblName: TcxLabel
      Style.IsFontAssigned = True
    end
    inherited edtDate: TcxDBDateEdit
      ExplicitHeight = 21
    end
    inherited edtCode: TcxDBTextEdit
      ExplicitHeight = 21
    end
    inherited DtlPageCtrl: TcxPageControl
      TabOrder = 7
      inherited tabMain: TcxTabSheet
        ExplicitWidth = 0
        ExplicitHeight = 0
      end
    end
    inherited edtCreate_time: TcxDBTimeEdit
      ExplicitHeight = 21
    end
    inherited imgCheck: TcxImage
      TabOrder = 6
    end
    inherited lblPrinted: TcxLabel
      Style.IsFontAssigned = True
    end
    inherited dynlblCreate_by: TcxLabel
      AnchorX = 221
    end
    inherited dynedtCreate_by: TcxDBLookupComboBox
      ExplicitHeight = 21
    end
    inherited dynlblCheck_by: TcxLabel
      AnchorX = 429
    end
    inherited dynedtCheck_by: TcxDBLookupComboBox
      ExplicitHeight = 21
    end
    inherited dynlblFilid: TcxLabel
      AnchorX = 88
    end
    inherited dynedtFilid: TcxDBLookupComboBox
      ExplicitHeight = 21
    end
    inherited dynlblDeptid: TcxLabel
      AnchorX = 301
    end
    inherited dynedtDeptid: TcxDBLookupComboBox
      ExplicitHeight = 21
    end
    inherited dynlblEmpid: TcxLabel
      AnchorX = 505
    end
    inherited dynedtEmpid: TcxDBLookupComboBox
      ExplicitHeight = 21
    end
    inherited dynlblBKind: TcxLabel
      AnchorX = 149
    end
    inherited dynedtBKind: TcxDBLookupComboBox
      ExplicitHeight = 21
    end
  end
  inherited Panel1: TPanel
    inherited labFuncName: TcxLabel
      Style.IsFontAssigned = True
    end
    inherited labFuncDesc: TcxLabel
      Style.IsFontAssigned = True
    end
  end
  inherited pnlTop: TPanel
    inherited edtPrint: TcxLookupComboBox
      ExplicitHeight = 21
    end
  end
  inherited pnlBottom: TPanel
    inherited barBill: TcxProgressBar
      ExplicitHeight = 21
    end
  end
  inherited cxStyleRepository1: TcxStyleRepository
    PixelsPerInch = 96
  end
  inherited qryDetail: TUniQuery
    SQLInsert.Strings = (
      'INSERT INTO tb_posscorecashbackdtl'
      
        '  (bid, bno, memberid, score, delscore, backamt, custom1, custom' +
        '2, custom3, custom4, custom5, custom6, custom7, custom8, custom9' +
        ', custom10, custom11, custom12, custom13, custom14, custom15, ex' +
        'plan)'
      'VALUES'
      
        '  (:bid, :bno, :memberid, :score, :delscore, :backamt, :custom1,' +
        ' :custom2, :custom3, :custom4, :custom5, :custom6, :custom7, :cu' +
        'stom8, :custom9, :custom10, :custom11, :custom12, :custom13, :cu' +
        'stom14, :custom15, :explan)')
    SQLDelete.Strings = (
      'DELETE FROM tb_posscorecashbackdtl'
      'WHERE'
      '  bid = :Old_bid AND bno = :Old_bno')
    SQLUpdate.Strings = (
      'UPDATE tb_posscorecashbackdtl'
      'SET'
      
        '  bid = :bid, bno = :bno, memberid = :memberid, score = :score, ' +
        'delscore = :delscore, backamt = :backamt, custom1 = :custom1, cu' +
        'stom2 = :custom2, custom3 = :custom3, custom4 = :custom4, custom' +
        '5 = :custom5, custom6 = :custom6, custom7 = :custom7, custom8 = ' +
        ':custom8, custom9 = :custom9, custom10 = :custom10, custom11 = :' +
        'custom11, custom12 = :custom12, custom13 = :custom13, custom14 =' +
        ' :custom14, custom15 = :custom15, explan = :explan'
      'WHERE'
      '  bid = :Old_bid AND bno = :Old_bno')
    SQLLock.Strings = (
      'SELECT * FROM tb_posscorecashbackdtl'
      'WITH (UPDLOCK, ROWLOCK, HOLDLOCK)'
      'WHERE'
      '  bid = :Old_bid AND bno = :Old_bno')
    SQLRefresh.Strings = (
      
        'SELECT bid, bno, memberid, score, delscore, backamt, custom1, cu' +
        'stom2, custom3, custom4, custom5, custom6, custom7, custom8, cus' +
        'tom9, custom10, custom11, custom12, custom13, custom14, custom15' +
        ', explan FROM tb_posscorecashbackdtl'
      'WHERE'
      '  bid = :Old_bid AND bno = :Old_bno')
    SQLRecCount.Strings = (
      'SET :PCOUNT = (SELECT COUNT(*) FROM tb_posscorecashbackdtl'
      ')')
    Connection = MainDM.UniConn
    SQL.Strings = (
      'select * from tb_posscorecashbackdtl')
  end
  inherited MainDataSet: TUniQuery
    SQLInsert.Strings = (
      'INSERT INTO tb_posscorecashback'
      
        '  (bid, bkind, bstate, bcode, bdate, filid, empid, create_by, ch' +
        'eck_by, deptid, voucherid, create_time, update_time, remark, sfl' +
        'ag, custom1, custom2, custom3, custom4, custom5, custom6, custom' +
        '7, custom8, custom9, custom10, custom11, custom12, custom13, cus' +
        'tom14, custom15, check_time)'
      'VALUES'
      
        '  (:bid, :bkind, :bstate, :bcode, :bdate, :filid, :empid, :creat' +
        'e_by, :check_by, :deptid, :voucherid, :create_time, :update_time' +
        ', :remark, :sflag, :custom1, :custom2, :custom3, :custom4, :cust' +
        'om5, :custom6, :custom7, :custom8, :custom9, :custom10, :custom1' +
        '1, :custom12, :custom13, :custom14, :custom15, :check_time)')
    SQLDelete.Strings = (
      'DELETE FROM tb_posscorecashback'
      'WHERE'
      '  bid = :Old_bid')
    SQLUpdate.Strings = (
      'UPDATE tb_posscorecashback'
      'SET'
      
        '  bid = :bid, bkind = :bkind, bstate = :bstate, bcode = :bcode, ' +
        'bdate = :bdate, filid = :filid, empid = :empid, create_by = :cre' +
        'ate_by, check_by = :check_by, deptid = :deptid, voucherid = :vou' +
        'cherid, create_time = :create_time, update_time = :update_time, ' +
        'remark = :remark, sflag = :sflag, custom1 = :custom1, custom2 = ' +
        ':custom2, custom3 = :custom3, custom4 = :custom4, custom5 = :cus' +
        'tom5, custom6 = :custom6, custom7 = :custom7, custom8 = :custom8' +
        ', custom9 = :custom9, custom10 = :custom10, custom11 = :custom11' +
        ', custom12 = :custom12, custom13 = :custom13, custom14 = :custom' +
        '14, custom15 = :custom15, check_time = :check_time'
      'WHERE'
      '  bid = :Old_bid')
    SQLLock.Strings = (
      'SELECT * FROM tb_posscorecashback'
      'WITH (UPDLOCK, ROWLOCK, HOLDLOCK)'
      'WHERE'
      '  bid = :Old_bid')
    SQLRefresh.Strings = (
      
        'SELECT bid, bkind, bstate, bcode, bdate, filid, empid, create_by' +
        ', check_by, deptid, voucherid, create_time, update_time, remark,' +
        ' sflag, custom1, custom2, custom3, custom4, custom5, custom6, cu' +
        'stom7, custom8, custom9, custom10, custom11, custom12, custom13,' +
        ' custom14, custom15, check_time FROM tb_posscorecashback'
      'WHERE'
      '  bid = :Old_bid')
    SQLRecCount.Strings = (
      'SET :PCOUNT = (SELECT COUNT(*) FROM tb_posscorecashback'
      ')')
    Connection = MainDM.UniConn
    SQL.Strings = (
      'select * from tb_posscorecashback')
  end
end
